use master
go
drop database spj
go
create database SPJ
go
use spj
go
 create table snabdjevac(
 s_no varchar(20),
 s_ime varchar(20),
 status integer,
 grad varchar(20),
 primary key (s_no)
 )
 go
 insert into snabdjevac(s_no,s_ime,status,grad)
 values ('s1','Stanko',20,'Podgorica')
 go
 insert into snabdjevac(s_no,s_ime,status,grad)
 values ('s2','Jovan',10,'Beograd')
 go
 insert into snabdjevac(s_no,s_ime,status,grad)
 values ('s3','Bozo',30,'Beograd')
 go
 insert into snabdjevac(s_no,s_ime,status,grad)
 values ('s4','Dejan',20,'Podgorica')
 go
 insert into snabdjevac(s_no,s_ime,status,grad)
 values ('s5','Igor',30,'Budva')
go
create table proizvod(
   p_no varchar(20),
   p_ime varchar(20),
   boja varchar (20),
   tezina decimal(10,4),
   grad varchar(20),
   primary key (p_no)
)
go
insert into proizvod(p_no, p_ime, boja, tezina, grad)
   values ('p1', 'Saraf', 'Crvena', 12, 'Podgorica')
go
insert into proizvod(p_no, p_ime, boja, tezina, grad)
   values ('p2', 'Otpornik', 'Zelena', 17, 'Beograd')
go
insert into proizvod(p_no, p_ime, boja, tezina, grad)
   values ('p3', 'Kondenzator', 'Plava', 17, 'Pljevlja')
go
insert into proizvod(p_no, p_ime, boja, tezina, grad)
   values ('p4', 'Kondenzator', 'Crvena', 14, 'Podgorica')
go
insert into proizvod(p_no, p_ime, boja, tezina, grad)
   values ('p5', 'Kabl', 'Plava', 12, 'Beograd')
go
insert into proizvod(p_no, p_ime, boja, tezina, grad)
   values ('p6', 'Uticnica', 'Crvena', 19, 'Podgorica')
go
create table fabrika(
f_no varchar(20),
f_ime varchar(20),
grad varchar(20),
primary key (f_no)
)
go
insert into fabrika(f_no,f_ime,grad)
  values ('F1','Video','Beograd')
go
insert into fabrika(f_no,f_ime,grad)
  values ('F2','Televizor','Pljevlja')
go
insert into fabrika(f_no,f_ime,grad)
  values ('F3','Muzicki stub','Budva')
go
insert into fabrika(f_no,f_ime,grad) 
  values ('F4','DVD plejer','Budva')
go
insert into fabrika(f_no,f_ime,grad) 
  values ('F5','Satelitska antena','Podgorica')
go
insert into fabrika(f_no,f_ime,grad)
  values ('F6','Kassetofon','Kragujevac')
go
insert into fabrika(f_no,f_ime,grad) 
  values ('F7','Kompjuter','Podgorica')
go

create table ISPORUKA (
S_NO varchar(20),
P_NO varchar(20),
F_NO varchar(20),
KOL FLOAT,
PRIMARY KEY (S_NO, P_NO, F_NO),
FOREIGN KEY (S_NO) REFERENCES SNABDJEVAC,
FOREIGN KEY (P_NO) REFERENCES PROIZVOD,
FOREIGN KEY (F_NO) REFERENCES FABRIKA
)
GO
INSERT INTO ISPORUKA (S_NO,P_NO, F_NO, KOL)
VALUES ('S1','P1','F1',200)
GO
INSERT INTO ISPORUKA (S_NO,P_NO, F_NO, KOL)
VALUES ('S1','P1','F4',700)
GO
INSERT INTO ISPORUKA (S_NO,P_NO, F_NO, KOL)
VALUES ('S2','P3','F1',400)
GO
INSERT INTO ISPORUKA (S_NO,P_NO, F_NO, KOL)
VALUES ('S2','P3','F2',200)
GO
INSERT INTO ISPORUKA (S_NO,P_NO, F_NO, KOL)
VALUES ('S2','P3','F3',200)
GO
INSERT INTO ISPORUKA (S_NO,P_NO, F_NO, KOL)
VALUES ('S2','P3','F4',500)
GO
INSERT INTO ISPORUKA (S_NO,P_NO, F_NO, KOL)
VALUES ('S2','P3','F5',600)
GO
INSERT INTO ISPORUKA (S_NO,P_NO, F_NO, KOL)
VALUES ('S2','P3','F6',400)
GO
INSERT INTO ISPORUKA (S_NO,P_NO, F_NO, KOL)
VALUES ('S2','P3','F7',800)
GO
INSERT INTO ISPORUKA (S_NO,P_NO, F_NO, KOL)
VALUES ('S2','P5','F2',100)
GO
INSERT INTO ISPORUKA (S_NO,P_NO, F_NO, KOL)
VALUES ('S3','P3','F1',200)
GO
INSERT INTO ISPORUKA (S_NO,P_NO, F_NO, KOL)
VALUES ('S3','P4','F2',500)
GO
INSERT INTO ISPORUKA (S_NO,P_NO, F_NO, KOL)
VALUES ('S4','P6','F3',300)
GO
INSERT INTO ISPORUKA (S_NO,P_NO, F_NO, KOL)
VALUES ('S4','P6','F7',300)
GO
INSERT INTO ISPORUKA (S_NO,P_NO, F_NO, KOL)
VALUES ('S5','P2','F2',200)
GO
INSERT INTO ISPORUKA (S_NO,P_NO, F_NO, KOL)
VALUES ('S5','P2','F4',100)
GO
INSERT INTO ISPORUKA (S_NO,P_NO, F_NO, KOL)
VALUES ('S5','P5','F5',500)
GO
INSERT INTO ISPORUKA (S_NO,P_NO, F_NO, KOL)
VALUES ('S5','P5','F7',100)
GO
INSERT INTO ISPORUKA (S_NO,P_NO, F_NO, KOL)
VALUES ('S5','P6','F2',200)
GO
INSERT INTO ISPORUKA (S_NO,P_NO, F_NO, KOL)
VALUES ('S5','P1','F4',100)
GO
INSERT INTO ISPORUKA (S_NO,P_NO, F_NO, KOL)
VALUES ('S5','P3','F4',200)
GO
INSERT INTO ISPORUKA (S_NO,P_NO, F_NO, KOL)
VALUES ('S5','P4','F4',800)
GO
INSERT INTO ISPORUKA (S_NO,P_NO, F_NO, KOL)
VALUES ('S5','P5','F4',400)
GO
INSERT INTO ISPORUKA (S_NO,P_NO, F_NO, KOL)
VALUES ('S5','P6','F4',500)
GO
select * from snabdjevac
go
select * from proizvod
go
select * from fabrika
go
select * from isporuka